package cn.huapu.power.energy.mapper;

import cn.huapu.power.energy.bean.Clientpowerst;
import cn.huapu.power.energy.bean.bo.DateParameterBo;
import cn.huapu.power.energy.bean.vo.ClientpowerstVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface ClientpowerstMapper extends BaseMapper<Clientpowerst, Integer> {

    /**
    * @Author jzx
    * @Description //统计月购买量与消费量
    * @Date 13:39 2019-6-17
    * @Param [da]
    * @return java.util.List<cn.huapu.power.energy.bean.vo.ClientpowerstVo>
    **/
    List<ClientpowerstVo> getWholeCableByMonth(@Param("id")int id,@Param("year") int year);

    /**
    * @Author jzx
    * @Description //统计年购买量与消费量
    * @Date 13:38 2019-6-17
    * @Param [da]
    * @return java.util.List<cn.huapu.power.energy.bean.vo.ClientpowerstVo>
    **/
    List<ClientpowerstVo> getWholeCableByYear(@Param("id")int id,@Param("yearSn") int yearSn,@Param("yearJn") int yearJn);

    List<Double> getElecWeek(@Param("id") int id, @Param("week")String week, @Param("week1")String week1);

    List<ClientpowerstVo> getDayBuyElec(DateParameterBo da);
    /**
     * 获取用户最大记录时间
     * @param clientId
     * @return
     */
    Clientpowerst getMaxTime(@Param("clientId") Integer clientId);
}